﻿CREATE TABLE [dbo].[Countries]
(
	[Id] [smallint] IDENTITY(1,1) NOT NULL,
	[Code] [varchar](50) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[CurrencyName] [varchar](50) NOT NULL,
	[CurrencyISOCode] [varchar](10) NOT NULL,
	[Convention] [varchar](50) NOT NULL,
	[TaxRate] [smallmoney] NULL,
	[IsVATIncluded] [bit] NOT NULL,
	[IsVATGeneral] [bit] NOT NULL,
	[ArticlesImporter] [varchar](200) NULL,
	[StoresImporter] [varchar](200) NULL,
	[SalesImporter] [varchar](200) NULL,
	[InventoryImporter] [varchar](200) NULL,
	[PIDifferencesImporter] [varchar](200) NULL,
	[SpacesImporter] [varchar](200) NULL,	
	[IsArticleMasterSeparateFile] [bit] NOT NULL,
	[IsStoreMasterSeparateFile] [bit] NOT NULL,
	[DailySales] [bit] NOT NULL
)
